Full source code website bán hàng thương mại điện tử gần giống shopee
468.981 lượt xem;
1 <?
2 echo $_SESSION["session_message"];
3 $_SESSION["session_message"] = "";
4 ?>
5 <table height="28" cellSpacing="0" cellPadding="0" width="100%" border="0">
6 <tr align=center>
7 <td class="title" width="100%">Đơn hàng : | 
8 </td>
9 </tr>
10 </table>
11 <?
12 switch ($_GET['action'])
13 {
14 case 'del' :
15 $id = $_GET['id'];
16 $sql = "delete from orders where orders_id='".$id."'";
17 $result = mysql_query($sql,$con);
18 if ($result)
19 {
20 $sql_del=mysql_query("delete from orderdetail where ordersdetail_ordersid='".$id."' ");
21 echo "<p align=center class='err'>Đã xóa thành công</p>";
22 }
23
24 else
25 {
26 echo "<p align=center class='err'>Không thể xóa dữ liệu</p>";
27 }
28 break;
29 }
30 ?>
31
32 <?
33 if (isset($_POST['ButDel'])) {
34 $cnt=0;
35 foreach ($_POST['chk'] as $id)
36 {
37 @$result = mysql_query("delete from orders where orders_id='".$id."'",$con);
38 if ($result)
39 {
40 $sql_del=mysql_query("delete from orderdetail where ordersdetail_ordersid='".$id."' ");
41 }
42 $cnt++;
43 }
44 echo "<p align=center class='err'>Đã xóa ".$cnt." phần tử</p>";
45 }
46 ?>
47
48 <?php
49 if (isset($_POST['xuly'])) {
50 $cnt=0;
51 foreach ($_POST['chk'] as $id)
52 {
53 $pro=GetProductInfo($id);
54 if ($pro)
55 {
56 @$result = mysql_query("update orders set active=1 where orders_id='".$id."'",$con);
57 if ($result) {
58 $cnt++;
59
60 }
61 }
62 }
63 echo "<p align=center class='err'>Đã xử lý ".$cnt." đơn hàng</p>";
64 }
65 ?>
66
67 <?
68 $page = $_GET["page"];
69 $p=0;
70 if ($page!='') $p=$page;
71 $where="1=1";
72 //if ($_REQUEST['status']!='') $where="products_status=".$_REQUEST['status']." ";
73 if ($_REQUEST['cat']!='') $where="orders_cat=".$_REQUEST['cat'];
74 ?>
75 <form method="POST" name="frmList" action="index.php">
76 <input type="hidden" name="act" value="order">
77 <input type=hidden name="page" value="<? echo $page; ?>">
78 <?
79 function taotrang($sql,$link,$nitem,$itemcurrent)
80 { global $con;
81 $ret="";
82 $result = mysql_query($sql, $con) or die('Error' . mysql_error());
83 $value = mysql_fetch_array($result);
84 $plus = (($value['cnt'] % $nitem)>0);
85 for ($i=0;$i<($value[0] / $nitem) + plus;$i++)
86 {
87 if ($i+1<>$itemcurrent) $ret .= "<a href=\"".$link.($i+1)."\" class=\"lslink\">".($i+1)."</a> ";
88 else $ret .= ($i+1)." ";
89 }
90 return $ret;
91 }
92 $pageindex=taotrang("select count(*) from orders","./?act=order&cat=".$_REQUEST['cat']."&page=",10,$page);
93 ?>
94
95 <table cellspacing="0" cellpadding="0">
96 <tr>
97 <td class="smallfont">Trang : <? echo $pageindex; ?></td>
98 </tr>
99 </table>
100
101 <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#C9C9C9" width="100%" id="AutoNumber1">
102 <tr>
103 <td align=center nowrap class="title"><input type="checkbox" name="chkall" onclick="chkallClick(this);"></td>
104 <td colspan="2" nowrap class="title">Trạng thái</td>
105 <td align="center" nowrap class="title"><b>Chi tiết</b></td>
106 <td align="center" nowrap class="title"><b>Mã đơn hàng</b></td>
107 <td align="center" nowrap class="title"><b>Số lượng sản phẩm</b></td>
108 <td align="center" nowrap class="title"><b>Tên khách hàng</b></td>
109 <td align="center" nowrap class="title"><b>Địa chỉ</b></td>
110 <td align="center" nowrap class="title"><b>Điện thoại</b></td>
111 <td align="center" nowrap class="title"><b>Email</b></td>
112 <td align="center" nowrap class="title"><b>Gian hàng</b></td>
113 <td align="center" nowrap class="title"><b>Date</b></td>
114
115 </tr>
116
117 <?php
118 $MAXPAGE=10;
119 $page = $_GET["page"];
120 $sql="select * from orders order by orders_date desc limit ".($p*$MAXPAGE).",".$MAXPAGE;
121 $result=mysql_query($sql,$con);
122 $i=0;
123 while(($row=mysql_fetch_array($result)))
124 {
125 $i++;
126 if ($i%2) $color="#d5d5d5"; else $color="#e5e5e5";
127 $cust=GetCustomerInfo($row['orders_customer_id']);
128 ?>
129
130 <tr>
131 <td bgcolor="<? echo $color; ?>" class="smallfont">
132 <p align="center"><input type="checkbox" name="chk[]" value="<? echo $row['orders_id']; ?>"></td>
133 <td bgcolor="<? echo $color; ?>" class="smallfont">
134 <p align="center">
135 <a <? echo $page?>"><?if($row['active']=='0'){?><img src="/quantri/css/un_active.png"><?}else{?><img src="/quantri/css/active.png"><?}?></a></td>
136 <td bgcolor="<? echo $color; ?>" class="smallfont">
137 <p align="center">
138 <a onclick="return confirm('Bạn có chắc chắn muốn xoá ?');" href="./?act=order&action=del&id=<? echo $row['orders_id']; ?>">Delete</a></td>
139 <td bgcolor="<? echo $color; ?>" class="smallfont" align="center"><input type="button" name="butDetail" value="Chi tiết" class="button" onclick="javascript:window.location='./?act=orderdetail&orderid=<? echo $row['orders_id']; ?>'"></td>
140 <td bgcolor="<? echo $color; ?>" align="center" class="smallfont"><? echo $row['orders_id']; ?> </td>
141 <td bgcolor="<? echo $color; ?>" align="center" class="smallfont"><? echo CountRecord('orderdetail','ordersdetail_ordersid='.$row['orders_id']); ?> </td>
142 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['orders_name']; ?> </td>
143 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['orders_address']; ?> </td>
144 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['orders_phone']; ?> </td>
145 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['orders_email']; ?> </td>
146 <td bgcolor="<? echo $color; ?>" class="smallfont"><a href="../<? echo $row['orders_user']; ?>" target="_blank"><? echo $row['orders_user']; ?></a> </td>
147 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['orders_date']; ?> </td>
148 </tr>
149 <?
150 }
151 ?>
152 </table>
153 <input type="submit" value="Xóa Chọn" name="ButDel" onclick="return confirm('Bạn có chắc chắn muốn xoá ?');" class="button">
154 <input type="submit" value="Xử lý" name="xuly" class="button">
155 </form>
156 <script language="JavaScript">
157 function chkallClick(o) {
158 var form = document.frmList;
159 for (var i = 0; i < form.elements.length; i++) {
160 if (form.elements[i].type == "checkbox" && form.elements[i].name!="chkall") {
161 form.elements[i].checked = document.frmList.chkall.checked;
162 }
163 }
164 }
165 </script>
2 echo $_SESSION["session_message"];
3 $_SESSION["session_message"] = "";
4 ?>
5 <table height="28" cellSpacing="0" cellPadding="0" width="100%" border="0">
6 <tr align=center>
7 <td class="title" width="100%">Đơn hàng : | 
8 </td>
9 </tr>
10 </table>
11 <?
12 switch ($_GET['action'])
13 {
14 case 'del' :
15 $id = $_GET['id'];
16 $sql = "delete from orders where orders_id='".$id."'";
17 $result = mysql_query($sql,$con);
18 if ($result)
19 {
20 $sql_del=mysql_query("delete from orderdetail where ordersdetail_ordersid='".$id."' ");
21 echo "<p align=center class='err'>Đã xóa thành công</p>";
22 }
23
24 else
25 {
26 echo "<p align=center class='err'>Không thể xóa dữ liệu</p>";
27 }
28 break;
29 }
30 ?>
31
32 <?
33 if (isset($_POST['ButDel'])) {
34 $cnt=0;
35 foreach ($_POST['chk'] as $id)
36 {
37 @$result = mysql_query("delete from orders where orders_id='".$id."'",$con);
38 if ($result)
39 {
40 $sql_del=mysql_query("delete from orderdetail where ordersdetail_ordersid='".$id."' ");
41 }
42 $cnt++;
43 }
44 echo "<p align=center class='err'>Đã xóa ".$cnt." phần tử</p>";
45 }
46 ?>
47
48 <?php
49 if (isset($_POST['xuly'])) {
50 $cnt=0;
51 foreach ($_POST['chk'] as $id)
52 {
53 $pro=GetProductInfo($id);
54 if ($pro)
55 {
56 @$result = mysql_query("update orders set active=1 where orders_id='".$id."'",$con);
57 if ($result) {
58 $cnt++;
59
60 }
61 }
62 }
63 echo "<p align=center class='err'>Đã xử lý ".$cnt." đơn hàng</p>";
64 }
65 ?>
66
67 <?
68 $page = $_GET["page"];
69 $p=0;
70 if ($page!='') $p=$page;
71 $where="1=1";
72 //if ($_REQUEST['status']!='') $where="products_status=".$_REQUEST['status']." ";
73 if ($_REQUEST['cat']!='') $where="orders_cat=".$_REQUEST['cat'];
74 ?>
75 <form method="POST" name="frmList" action="index.php">
76 <input type="hidden" name="act" value="order">
77 <input type=hidden name="page" value="<? echo $page; ?>">
78 <?
79 function taotrang($sql,$link,$nitem,$itemcurrent)
80 { global $con;
81 $ret="";
82 $result = mysql_query($sql, $con) or die('Error' . mysql_error());
83 $value = mysql_fetch_array($result);
84 $plus = (($value['cnt'] % $nitem)>0);
85 for ($i=0;$i<($value[0] / $nitem) + plus;$i++)
86 {
87 if ($i+1<>$itemcurrent) $ret .= "<a href=\"".$link.($i+1)."\" class=\"lslink\">".($i+1)."</a> ";
88 else $ret .= ($i+1)." ";
89 }
90 return $ret;
91 }
92 $pageindex=taotrang("select count(*) from orders","./?act=order&cat=".$_REQUEST['cat']."&page=",10,$page);
93 ?>
94
95 <table cellspacing="0" cellpadding="0">
96 <tr>
97 <td class="smallfont">Trang : <? echo $pageindex; ?></td>
98 </tr>
99 </table>
100
101 <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#C9C9C9" width="100%" id="AutoNumber1">
102 <tr>
103 <td align=center nowrap class="title"><input type="checkbox" name="chkall" onclick="chkallClick(this);"></td>
104 <td colspan="2" nowrap class="title">Trạng thái</td>
105 <td align="center" nowrap class="title"><b>Chi tiết</b></td>
106 <td align="center" nowrap class="title"><b>Mã đơn hàng</b></td>
107 <td align="center" nowrap class="title"><b>Số lượng sản phẩm</b></td>
108 <td align="center" nowrap class="title"><b>Tên khách hàng</b></td>
109 <td align="center" nowrap class="title"><b>Địa chỉ</b></td>
110 <td align="center" nowrap class="title"><b>Điện thoại</b></td>
111 <td align="center" nowrap class="title"><b>Email</b></td>
112 <td align="center" nowrap class="title"><b>Gian hàng</b></td>
113 <td align="center" nowrap class="title"><b>Date</b></td>
114
115 </tr>
116
117 <?php
118 $MAXPAGE=10;
119 $page = $_GET["page"];
120 $sql="select * from orders order by orders_date desc limit ".($p*$MAXPAGE).",".$MAXPAGE;
121 $result=mysql_query($sql,$con);
122 $i=0;
123 while(($row=mysql_fetch_array($result)))
124 {
125 $i++;
126 if ($i%2) $color="#d5d5d5"; else $color="#e5e5e5";
127 $cust=GetCustomerInfo($row['orders_customer_id']);
128 ?>
129
130 <tr>
131 <td bgcolor="<? echo $color; ?>" class="smallfont">
132 <p align="center"><input type="checkbox" name="chk[]" value="<? echo $row['orders_id']; ?>"></td>
133 <td bgcolor="<? echo $color; ?>" class="smallfont">
134 <p align="center">
135 <a <? echo $page?>"><?if($row['active']=='0'){?><img src="/quantri/css/un_active.png"><?}else{?><img src="/quantri/css/active.png"><?}?></a></td>
136 <td bgcolor="<? echo $color; ?>" class="smallfont">
137 <p align="center">
138 <a onclick="return confirm('Bạn có chắc chắn muốn xoá ?');" href="./?act=order&action=del&id=<? echo $row['orders_id']; ?>">Delete</a></td>
139 <td bgcolor="<? echo $color; ?>" class="smallfont" align="center"><input type="button" name="butDetail" value="Chi tiết" class="button" onclick="javascript:window.location='./?act=orderdetail&orderid=<? echo $row['orders_id']; ?>'"></td>
140 <td bgcolor="<? echo $color; ?>" align="center" class="smallfont"><? echo $row['orders_id']; ?> </td>
141 <td bgcolor="<? echo $color; ?>" align="center" class="smallfont"><? echo CountRecord('orderdetail','ordersdetail_ordersid='.$row['orders_id']); ?> </td>
142 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['orders_name']; ?> </td>
143 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['orders_address']; ?> </td>
144 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['orders_phone']; ?> </td>
145 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['orders_email']; ?> </td>
146 <td bgcolor="<? echo $color; ?>" class="smallfont"><a href="../<? echo $row['orders_user']; ?>" target="_blank"><? echo $row['orders_user']; ?></a> </td>
147 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['orders_date']; ?> </td>
148 </tr>
149 <?
150 }
151 ?>
152 </table>
153 <input type="submit" value="Xóa Chọn" name="ButDel" onclick="return confirm('Bạn có chắc chắn muốn xoá ?');" class="button">
154 <input type="submit" value="Xử lý" name="xuly" class="button">
155 </form>
156 <script language="JavaScript">
157 function chkallClick(o) {
158 var form = document.frmList;
159 for (var i = 0; i < form.elements.length; i++) {
160 if (form.elements[i].type == "checkbox" && form.elements[i].name!="chkall") {
161 form.elements[i].checked = document.frmList.chkall.checked;
162 }
163 }
164 }
165 </script>